/**
 * 
 */
package de.alex.schulzeit.db.subjecttable;

/**
 * @author Alex Ruetz
 *
 */
public final class TableSubjectTable implements TableSubjectColumns {
	
	public static final String TABLE_NAME = TableSubjectTable.class.getSimpleName();
	
	public static final String SQL_CREATE = "CREATE TABLE " + TABLE_NAME + " (" + 
		ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " + 
		SUBJECT_ID + " INTEGER NOT NULL, " + 
		TEACHER_ID + " INTEGER NOT NULL, " + 
		TIMETABLE_ID + " INTEGER NOT NULL, " +
		DAY + " INTEGER NOT NULL, " + 
		HOUR + " INTEGER NOT NULL);";
	
	public static final String SQL_DROP = "DROP TABLE IF EXISTS " + TABLE_NAME;
	
	public static final String SQL_DUMMY1 = "INSERT INTO " + TABLE_NAME + " (" +
	SUBJECT_ID + ", " + TEACHER_ID + ", " + TIMETABLE_ID + ", " + 
	DAY + ", " + HOUR + ") VALUES ('1', '2', '1', '1', '1');";
	
	public static final String SQL_DUMMY2 = "INSERT INTO " + TABLE_NAME + " (" +
	SUBJECT_ID + ", " + TEACHER_ID + ", " + TIMETABLE_ID + ", " + 
	DAY + ", " + HOUR + ") VALUES ('2', '3', '1', '1', '5');";
	
	public static final String SQL_DUMMY3 = "INSERT INTO " + TABLE_NAME + " (" +
	SUBJECT_ID + ", " + TEACHER_ID + ", " + TIMETABLE_ID + ", " + 
	DAY + ", " + HOUR + ") VALUES ('3', '1', '1', '2', '1');";
	
	public static final String SQL_DUMMY4 = "INSERT INTO " + TABLE_NAME + " (" +
	SUBJECT_ID + ", " + TEACHER_ID + ", " + TIMETABLE_ID + ", " + 
	DAY + ", " + HOUR + ") VALUES ('4', '2', '1', '3', '3');";
}
